BEGIN;
	CREATE TABLE requests(
		id BIGSERIAL PRIMARY KEY,
		facebook_user_id BIGINT NOT NULL,
		category_id BIGINT REFERENCES categories(id) NOT NULL,
		title VARCHAR NOT NULL,
		description TEXT,
		tags VARCHAR[]
	);
	CREATE INDEX requests_facebook_user_id_index ON requests (facebook_user_id);
	CREATE INDEX requests_category_id_index ON requests (category_id);
	CREATE INDEX requests_title_index ON requests (title);
	CREATE INDEX requests_tags_index ON requests USING GIN (tags);
END;
